Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	16376
Missing cells	0
Missing cells (%)	0.0%
Total size in memory	2.9 MiB
Average record size in memory	184.0 B

Variable types

Numeric	21
Categorical	2

Alerts

`sum_services` is highly correlated with `services_frequency` and 1 other fields	High correlation
`services_frequency` is highly correlated with `sum_services` and 1 other fields	High correlation
`inter_avulsa` is highly correlated with `services_frequency`	High correlation
`prezao_semanal` is highly correlated with `sum_services`	High correlation
`sum_services` is highly correlated with `services_frequency` and 1 other fields	High correlation
`services_frequency` is highly correlated with `sum_services` and 1 other fields	High correlation
`inter_avulsa` is highly correlated with `services_frequency`	High correlation
`prezao_semanal` is highly correlated with `sum_services`	High correlation
`sum_services` is highly correlated with `services_frequency`	High correlation
`services_frequency` is highly correlated with `sum_services`	High correlation
`sum_services` is highly correlated with `services_frequency` and 2 other fields	High correlation
`services_frequency` is highly correlated with `sum_services` and 3 other fields	High correlation
`inter_avulsa` is highly correlated with `sum_services` and 1 other fields	High correlation
`clube` is highly correlated with `pct_internet_mensal`	High correlation
`entretenimento` is highly correlated with `prezao_mensal` and 2 other fields	High correlation
`pct_internet_mensal` is highly correlated with `clube`	High correlation
`prezao_diario` is highly correlated with `services_frequency`	High correlation
`prezao_mensal` is highly correlated with `entretenimento`	High correlation
`prezao_semanal` is highly correlated with `sum_services`	High correlation
`servicos_operadora` is highly correlated with `services_frequency`	High correlation
`sms_internacional` is highly correlated with `entretenimento` and 1 other fields	High correlation
`transf_entre_regionais` is highly correlated with `entretenimento` and 1 other fields	High correlation
`antivirus` is highly skewed (γ1 = 34.85832138)	Skewed
`app_emprego` is highly skewed (γ1 = 29.21980657)	Skewed
`app_saude` is highly skewed (γ1 = 32.83317862)	Skewed
`clube` is highly skewed (γ1 = 50.13195303)	Skewed
`prezao_quinzenal` is highly skewed (γ1 = 20.05624131)	Skewed
`recarga_sos` is highly skewed (γ1 = 24.06023604)	Skewed
`sms_cobrar` is highly skewed (γ1 = 52.74284097)	Skewed
`sms_internacional` is highly skewed (γ1 = 22.32782473)	Skewed
`inter_avulsa` has 7474 (45.6%) zeros	Zeros
`antivirus` has 16290 (99.5%) zeros	Zeros
`app_educacao` has 16256 (99.3%) zeros	Zeros
`app_emprego` has 16303 (99.6%) zeros	Zeros
`app_saude` has 16314 (99.6%) zeros	Zeros
`clube` has 13180 (80.5%) zeros	Zeros
`pre_mix_giga` has 16240 (99.2%) zeros	Zeros
`entretenimento` has 14570 (89.0%) zeros	Zeros
`games` has 16137 (98.5%) zeros	Zeros
`pct_internet_mensal` has 15513 (94.7%) zeros	Zeros
`prezao_diario` has 8736 (53.3%) zeros	Zeros
`prezao_mensal` has 14370 (87.8%) zeros	Zeros
`prezao_quinzenal` has 16295 (99.5%) zeros	Zeros
`prezao_semanal` has 7924 (48.4%) zeros	Zeros
`recarga_sos` has 16294 (99.5%) zeros	Zeros
`servicos_operadora` has 12747 (77.8%) zeros	Zeros
`sms_cobrar` has 16185 (98.8%) zeros	Zeros
`sms_internacional` has 16109 (98.4%) zeros	Zeros
`truecaller` has 16174 (98.8%) zeros	Zeros

Reproduction

Analysis started	2022-03-22 22:37:13.408419
Analysis finished	2022-03-22 22:37:52.025808
Duration	38.62 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

sum_services
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8083
Distinct (%)	49.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.54977101

Minimum	0.01
Maximum	1202.26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	4.47
Q1	19.98
median	46.18
Q3	100.1125
95-th percentile	194.87
Maximum	1202.26
Range	1202.25
Interquartile range (IQR)	80.1325

Descriptive statistics

Standard deviation	68.74195725
Coefficient of variation (CV)	1.002803602
Kurtosis	13.44805669
Mean	68.54977101
Median Absolute Deviation (MAD)	32.485
Skewness	2.465129991
Sum	1122571.05
Variance	4725.456687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.99	422	2.6%
19.98	221	1.3%
19.99	164	1.0%
29.97	119	0.7%
39.96	73	0.4%
1.99	72	0.4%
1.49	72	0.4%
129.87	70	0.4%
44.97	64	0.4%
2.98	62	0.4%
Other values (8073)	15037	91.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	2	< 0.1%
0.02	4	< 0.1%
0.03	1	< 0.1%
0.04	3	< 0.1%
0.05	5	< 0.1%
0.06	2	< 0.1%
0.08	1	< 0.1%
0.09	3	< 0.1%
0.11	2	< 0.1%
0.12	3	< 0.1%

Value	Count	Frequency (%)
1202.26	1	< 0.1%
885.59	1	< 0.1%
772.47	1	< 0.1%
691.63	1	< 0.1%
671.96	1	< 0.1%
669.54	1	< 0.1%
647.07	1	< 0.1%
632.84	1	< 0.1%
629.58	1	< 0.1%
611	1	< 0.1%

services_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	173
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.65138007

Minimum	1
Maximum	448
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	5
median	12
Q3	24
95-th percentile	59
Maximum	448
Range	447
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	21.59358786
Coefficient of variation (CV)	1.157747458
Kurtosis	25.21450875
Mean	18.65138007
Median Absolute Deviation (MAD)	8
Skewness	3.462621231
Sum	305435
Variance	466.2830369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1128	6.9%
3	934	5.7%
2	919	5.6%
4	794	4.8%
5	690	4.2%
6	668	4.1%
7	636	3.9%
8	592	3.6%
13	538	3.3%
9	516	3.2%
Other values (163)	8961	54.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1128	6.9%
2	919	5.6%
3	934	5.7%
4	794	4.8%
5	690	4.2%
6	668	4.1%
7	636	3.9%
8	592	3.6%
9	516	3.2%
10	453	2.8%

Value	Count	Frequency (%)
448	1	< 0.1%
328	1	< 0.1%
258	1	< 0.1%
243	1	< 0.1%
233	1	< 0.1%
232	1	< 0.1%
231	1	< 0.1%
224	1	< 0.1%
219	1	< 0.1%
216	1	< 0.1%

inter_avulsa
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	157
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.404433317

Minimum	0
Maximum	447
Zeros	7474
Zeros (%)	45.6%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	8
95-th percentile	43
Maximum	447
Range	447
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	18.05257198
Coefficient of variation (CV)	2.147982059
Kurtosis	42.0884869
Mean	8.404433317
Median Absolute Deviation (MAD)	1
Skewness	4.669133181
Sum	137631
Variance	325.895355
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7474	45.6%
1	1371	8.4%
2	821	5.0%
3	624	3.8%
4	531	3.2%
5	426	2.6%
6	410	2.5%
7	353	2.2%
8	305	1.9%
9	294	1.8%
Other values (147)	3767	23.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7474	45.6%
1	1371	8.4%
2	821	5.0%
3	624	3.8%
4	531	3.2%
5	426	2.6%
6	410	2.5%
7	353	2.2%
8	305	1.9%
9	294	1.8%

Value	Count	Frequency (%)
447	1	< 0.1%
219	1	< 0.1%
215	1	< 0.1%
211	1	< 0.1%
205	1	< 0.1%
200	1	< 0.1%
197	1	< 0.1%
184	1	< 0.1%
181	1	< 0.1%
176	1	< 0.1%

antivirus
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01618221788

Minimum	0
Maximum	21
Zeros	16290
Zeros (%)	99.5%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.32359731
Coefficient of variation (CV)	19.99709264
Kurtosis	1637.488782
Mean	0.01618221788
Median Absolute Deviation (MAD)	0
Skewness	34.85832138
Sum	265
Variance	0.1047152191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	16290	99.5%
1	36	0.2%
2	14	0.1%
3	11	0.1%
5	9	0.1%
4	7	< 0.1%
6	3	< 0.1%
12	2	< 0.1%
21	1	< 0.1%
8	1	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16290	99.5%
1	36	0.2%
2	14	0.1%
3	11	0.1%
4	7	< 0.1%
5	9	0.1%
6	3	< 0.1%
8	1	< 0.1%
11	1	< 0.1%
12	2	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
13	1	< 0.1%
12	2	< 0.1%
11	1	< 0.1%
8	1	< 0.1%
6	3	< 0.1%
5	9	0.1%
4	7	< 0.1%
3	11	0.1%
2	14	0.1%

app_educacao
Real number (ℝ_≥0)

ZEROS

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01917440156

Minimum	0
Maximum	10
Zeros	16256
Zeros (%)	99.3%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2765081325
Coefficient of variation (CV)	14.42069165
Kurtosis	422.3448772
Mean	0.01917440156
Median Absolute Deviation (MAD)	0
Skewness	18.95147522
Sum	314
Variance	0.07645674735
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	16256	99.3%
1	47	0.3%
2	28	0.2%
3	12	0.1%
4	12	0.1%
6	8	< 0.1%
5	8	< 0.1%
7	3	< 0.1%
10	1	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16256	99.3%
1	47	0.3%
2	28	0.2%
3	12	0.1%
4	12	0.1%
5	8	< 0.1%
6	8	< 0.1%
7	3	< 0.1%
8	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
8	1	< 0.1%
7	3	< 0.1%
6	8	< 0.1%
5	8	< 0.1%
4	12	0.1%
3	12	0.1%
2	28	0.2%
1	47	0.3%
0	16256	99.3%

app_emprego
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01581582804

Minimum	0
Maximum	16
Zeros	16303
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	16
Range	16
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.324181054
Coefficient of variation (CV)	20.49725459
Kurtosis	1023.737651
Mean	0.01581582804
Median Absolute Deviation (MAD)	0
Skewness	29.21980657
Sum	259
Variance	0.1050933558
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	16303	99.6%
1	28	0.2%
2	10	0.1%
3	9	0.1%
4	7	< 0.1%
7	4	< 0.1%
5	4	< 0.1%
6	3	< 0.1%
13	2	< 0.1%
10	2	< 0.1%
Other values (4)	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16303	99.6%
1	28	0.2%
2	10	0.1%
3	9	0.1%
4	7	< 0.1%
5	4	< 0.1%
6	3	< 0.1%
7	4	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
16	1	< 0.1%
13	2	< 0.1%
11	1	< 0.1%
10	2	< 0.1%
9	1	< 0.1%
8	1	< 0.1%
7	4	< 0.1%
6	3	< 0.1%
5	4	< 0.1%
4	7	< 0.1%

app_saude
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01141914998

Minimum	0
Maximum	13
Zeros	16314
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	13
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2602247553
Coefficient of variation (CV)	22.78845237
Kurtosis	1258.119659
Mean	0.01141914998
Median Absolute Deviation (MAD)	0
Skewness	32.83317862
Sum	187
Variance	0.06771692329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	16314	99.6%
1	28	0.2%
2	12	0.1%
3	5	< 0.1%
4	5	< 0.1%
8	3	< 0.1%
6	2	< 0.1%
5	2	< 0.1%
9	2	< 0.1%
13	1	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16314	99.6%
1	28	0.2%
2	12	0.1%
3	5	< 0.1%
4	5	< 0.1%
5	2	< 0.1%
6	2	< 0.1%
8	3	< 0.1%
9	2	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
13	1	< 0.1%
12	1	< 0.1%
11	1	< 0.1%
9	2	< 0.1%
8	3	< 0.1%
6	2	< 0.1%
5	2	< 0.1%
4	5	< 0.1%
3	5	< 0.1%
2	12	0.1%

clube
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3760991695

Minimum	0
Maximum	155
Zeros	13180
Zeros (%)	80.5%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	155
Range	155
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.715855209
Coefficient of variation (CV)	4.562241419
Kurtosis	4180.218843
Mean	0.3760991695
Median Absolute Deviation (MAD)	0
Skewness	50.13195303
Sum	6159
Variance	2.944159097
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	13180	80.5%
1	2023	12.4%
2	621	3.8%
3	242	1.5%
4	95	0.6%
5	66	0.4%
6	55	0.3%
7	31	0.2%
9	16	0.1%
12	9	0.1%
Other values (12)	38	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13180	80.5%
1	2023	12.4%
2	621	3.8%
3	242	1.5%
4	95	0.6%
5	66	0.4%
6	55	0.3%
7	31	0.2%
8	8	< 0.1%
9	16	0.1%

Value	Count	Frequency (%)
155	1	< 0.1%
67	1	< 0.1%
29	1	< 0.1%
26	1	< 0.1%
20	1	< 0.1%
16	1	< 0.1%
15	2	< 0.1%
14	3	< 0.1%
13	4	< 0.1%
12	9	0.1%

pre_mix_giga
Real number (ℝ_≥0)

ZEROS

Distinct	19
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.07010258915

Minimum	0
Maximum	43
Zeros	16240
Zeros (%)	99.2%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	43
Range	43
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9089721476
Coefficient of variation (CV)	12.96631349
Kurtosis	482.1004591
Mean	0.07010258915
Median Absolute Deviation (MAD)	0
Skewness	18.09212166
Sum	1148
Variance	0.826230365
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	16240	99.2%
13	19	0.1%
12	12	0.1%
10	11	0.1%
6	11	0.1%
5	11	0.1%
11	11	0.1%
4	10	0.1%
2	10	0.1%
7	8	< 0.1%
Other values (9)	33	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16240	99.2%
1	7	< 0.1%
2	10	0.1%
3	7	< 0.1%
4	10	0.1%
5	11	0.1%
6	11	0.1%
7	8	< 0.1%
8	4	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
43	1	< 0.1%
27	1	< 0.1%
17	2	< 0.1%
15	1	< 0.1%
14	4	< 0.1%
13	19	0.1%
12	12	0.1%
11	11	0.1%
10	11	0.1%
9	6	< 0.1%

entretenimento
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	32
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5950781632

Minimum	0
Maximum	40
Zeros	14570
Zeros (%)	89.0%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4
Maximum	40
Range	40
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.344888393
Coefficient of variation (CV)	3.940471249
Kurtosis	41.87825215
Mean	0.5950781632
Median Absolute Deviation (MAD)	0
Skewness	5.662629935
Sum	9745
Variance	5.498501576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	14570	89.0%
1	395	2.4%
2	265	1.6%
3	200	1.2%
4	170	1.0%
5	124	0.8%
6	99	0.6%
7	82	0.5%
13	76	0.5%
8	71	0.4%
Other values (22)	324	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	14570	89.0%
1	395	2.4%
2	265	1.6%
3	200	1.2%
4	170	1.0%
5	124	0.8%
6	99	0.6%
7	82	0.5%
8	71	0.4%
9	60	0.4%

Value	Count	Frequency (%)
40	1	< 0.1%
38	1	< 0.1%
34	1	< 0.1%
29	1	< 0.1%
27	2	< 0.1%
26	3	< 0.1%
25	3	< 0.1%
24	6	< 0.1%
23	2	< 0.1%
22	2	< 0.1%

games
Real number (ℝ_≥0)

ZEROS

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03529555447

Minimum	0
Maximum	15
Zeros	16137
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4004271894
Coefficient of variation (CV)	11.34497518
Kurtosis	421.3665179
Mean	0.03529555447
Median Absolute Deviation (MAD)	0
Skewness	18.1380017
Sum	578
Variance	0.160341934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	16137	98.5%
1	120	0.7%
2	46	0.3%
3	30	0.2%
4	14	0.1%
5	8	< 0.1%
6	5	< 0.1%
8	5	< 0.1%
10	3	< 0.1%
11	3	< 0.1%
Other values (3)	5	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16137	98.5%
1	120	0.7%
2	46	0.3%
3	30	0.2%
4	14	0.1%
5	8	< 0.1%
6	5	< 0.1%
7	2	< 0.1%
8	5	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
11	3	< 0.1%
10	3	< 0.1%
9	2	< 0.1%
8	5	< 0.1%
7	2	< 0.1%
6	5	< 0.1%
5	8	< 0.1%
4	14	0.1%
3	30	0.2%

pct_internet_mensal
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.09452857841

Minimum	0
Maximum	15
Zeros	15513
Zeros (%)	94.7%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5412831665
Coefficient of variation (CV)	5.726132516
Kurtosis	164.1668929
Mean	0.09452857841
Median Absolute Deviation (MAD)	0
Skewness	10.5229222
Sum	1548
Variance	0.2929874663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	15513	94.7%
1	556	3.4%
2	145	0.9%
3	87	0.5%
4	29	0.2%
5	16	0.1%
6	9	0.1%
8	8	< 0.1%
7	4	< 0.1%
9	3	< 0.1%
Other values (5)	6	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15513	94.7%
1	556	3.4%
2	145	0.9%
3	87	0.5%
4	29	0.2%
5	16	0.1%
6	9	0.1%
7	4	< 0.1%
8	8	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
14	1	< 0.1%
12	1	< 0.1%
11	1	< 0.1%
10	2	< 0.1%
9	3	< 0.1%
8	8	< 0.1%
7	4	< 0.1%
6	9	0.1%
5	16	0.1%

prezao_diario
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	98
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.655532487

Minimum	0
Maximum	134
Zeros	8736
Zeros (%)	53.3%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5
95-th percentile	22
Maximum	134
Range	134
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	9.634188038
Coefficient of variation (CV)	2.069406253
Kurtosis	24.32789976
Mean	4.655532487
Median Absolute Deviation (MAD)	0
Skewness	4.084420719
Sum	76239
Variance	92.81757916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8736	53.3%
1	1047	6.4%
2	816	5.0%
3	681	4.2%
4	545	3.3%
5	538	3.3%
6	429	2.6%
7	387	2.4%
8	319	1.9%
9	276	1.7%
Other values (88)	2602	15.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8736	53.3%
1	1047	6.4%
2	816	5.0%
3	681	4.2%
4	545	3.3%
5	538	3.3%
6	429	2.6%
7	387	2.4%
8	319	1.9%
9	276	1.7%

Value	Count	Frequency (%)
134	1	< 0.1%
130	1	< 0.1%
109	1	< 0.1%
105	1	< 0.1%
103	1	< 0.1%
102	1	< 0.1%
97	1	< 0.1%
96	2	< 0.1%
92	1	< 0.1%
91	2	< 0.1%

prezao_mensal
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2537860283

Minimum	0
Maximum	18
Zeros	14370
Zeros (%)	87.8%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8064346286
Coefficient of variation (CV)	3.177616332
Kurtosis	32.25618017
Mean	0.2537860283
Median Absolute Deviation (MAD)	0
Skewness	4.424935011
Sum	4156
Variance	0.6503368102
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	14370	87.8%
1	813	5.0%
2	555	3.4%
3	471	2.9%
4	90	0.5%
5	41	0.3%
6	20	0.1%
7	7	< 0.1%
8	4	< 0.1%
9	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	14370	87.8%
1	813	5.0%
2	555	3.4%
3	471	2.9%
4	90	0.5%
5	41	0.3%
6	20	0.1%
7	7	< 0.1%
8	4	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
9	4	< 0.1%
8	4	< 0.1%
7	7	< 0.1%
6	20	0.1%
5	41	0.3%
4	90	0.5%
3	471	2.9%
2	555	3.4%
1	813	5.0%

prezao_quinzenal
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02167806546

Minimum	0
Maximum	14
Zeros	16295
Zeros (%)	99.5%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	14
Range	14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3534177112
Coefficient of variation (CV)	16.30300969
Kurtosis	486.393935
Mean	0.02167806546
Median Absolute Deviation (MAD)	0
Skewness	20.05624131
Sum	355
Variance	0.1249040786
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	16295	99.5%
3	17	0.1%
6	15	0.1%
1	12	0.1%
5	10	0.1%
7	9	0.1%
4	9	0.1%
2	5	< 0.1%
8	2	< 0.1%
13	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16295	99.5%
1	12	0.1%
2	5	< 0.1%
3	17	0.1%
4	9	0.1%
5	10	0.1%
6	15	0.1%
7	9	0.1%
8	2	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
13	1	< 0.1%
8	2	< 0.1%
7	9	0.1%
6	15	0.1%
5	10	0.1%
4	9	0.1%
3	17	0.1%
2	5	< 0.1%
1	12	0.1%

prezao_semanal
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	37
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.09062042

Minimum	0
Maximum	39
Zeros	7924
Zeros (%)	48.4%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	5
95-th percentile	13
Maximum	39
Range	39
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.614504311
Coefficient of variation (CV)	1.493067308
Kurtosis	4.303137982
Mean	3.09062042
Median Absolute Deviation (MAD)	1
Skewness	1.887970321
Sum	50612
Variance	21.29365003
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	7924	48.4%
1	1545	9.4%
2	1121	6.8%
3	854	5.2%
4	684	4.2%
5	589	3.6%
13	503	3.1%
6	483	2.9%
7	415	2.5%
12	402	2.5%
Other values (27)	1856	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7924	48.4%
1	1545	9.4%
2	1121	6.8%
3	854	5.2%
4	684	4.2%
5	589	3.6%
6	483	2.9%
7	415	2.5%
8	384	2.3%
9	338	2.1%

Value	Count	Frequency (%)
39	1	< 0.1%
38	1	< 0.1%
37	2	< 0.1%
36	2	< 0.1%
32	1	< 0.1%
31	1	< 0.1%
30	7	< 0.1%
29	8	< 0.1%
28	6	< 0.1%
27	6	< 0.1%

recarga_sos
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.011358085

Minimum	0
Maximum	8
Zeros	16294
Zeros (%)	99.5%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	8
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.19860389
Coefficient of variation (CV)	17.48568442
Kurtosis	691.2109646
Mean	0.011358085
Median Absolute Deviation (MAD)	0
Skewness	24.06023604
Sum	186
Variance	0.03944350511
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	16294	99.5%
1	34	0.2%
2	27	0.2%
4	6	< 0.1%
3	6	< 0.1%
6	4	< 0.1%
5	2	< 0.1%
7	2	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16294	99.5%
1	34	0.2%
2	27	0.2%
3	6	< 0.1%
4	6	< 0.1%
5	2	< 0.1%
6	4	< 0.1%
7	2	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	2	< 0.1%
6	4	< 0.1%
5	2	< 0.1%
4	6	< 0.1%
3	6	< 0.1%
2	27	0.2%
1	34	0.2%
0	16294	99.5%

servicos_operadora
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	32
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6511358085

Minimum	0
Maximum	36
Zeros	12747
Zeros (%)	77.8%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	36
Range	36
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.245891093
Coefficient of variation (CV)	3.44918996
Kurtosis	44.37784879
Mean	0.6511358085
Median Absolute Deviation (MAD)	0
Skewness	5.90642401
Sum	10663
Variance	5.044026801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	12747	77.8%
1	2298	14.0%
2	419	2.6%
3	174	1.1%
4	111	0.7%
5	72	0.4%
8	66	0.4%
12	63	0.4%
13	61	0.4%
7	61	0.4%
Other values (22)	304	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	12747	77.8%
1	2298	14.0%
2	419	2.6%
3	174	1.1%
4	111	0.7%
5	72	0.4%
6	56	0.3%
7	61	0.4%
8	66	0.4%
9	47	0.3%

Value	Count	Frequency (%)
36	1	< 0.1%
35	1	< 0.1%
31	2	< 0.1%
30	1	< 0.1%
28	2	< 0.1%
27	1	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
23	1	< 0.1%
22	6	< 0.1%

sms_cobrar
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	19
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04683683439

Minimum	0
Maximum	79
Zeros	16185
Zeros (%)	98.8%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	79
Range	79
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.122512888
Coefficient of variation (CV)	23.9664551
Kurtosis	3329.04267
Mean	0.04683683439
Median Absolute Deviation (MAD)	0
Skewness	52.74284097
Sum	767
Variance	1.260035185
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	16185	98.8%
1	112	0.7%
2	25	0.2%
3	11	0.1%
4	9	0.1%
6	9	0.1%
5	5	< 0.1%
8	4	< 0.1%
7	3	< 0.1%
79	2	< 0.1%
Other values (9)	11	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16185	98.8%
1	112	0.7%
2	25	0.2%
3	11	0.1%
4	9	0.1%
5	5	< 0.1%
6	9	0.1%
7	3	< 0.1%
8	4	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
79	2	< 0.1%
49	1	< 0.1%
33	1	< 0.1%
29	2	< 0.1%
22	1	< 0.1%
17	2	< 0.1%
15	1	< 0.1%
14	1	< 0.1%
12	1	< 0.1%
9	1	< 0.1%

sms_internacional
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0268075232

Minimum	0
Maximum	14
Zeros	16109
Zeros (%)	98.4%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	14
Range	14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2816777973
Coefficient of variation (CV)	10.50741597
Kurtosis	793.7408493
Mean	0.0268075232
Median Absolute Deviation (MAD)	0
Skewness	22.32782473
Sum	439
Variance	0.07934238152
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	16109	98.4%
1	180	1.1%
2	55	0.3%
3	13	0.1%
4	9	0.1%
5	4	< 0.1%
6	2	< 0.1%
13	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16109	98.4%
1	180	1.1%
2	55	0.3%
3	13	0.1%
4	9	0.1%
5	4	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
13	1	< 0.1%
8	1	< 0.1%
7	1	< 0.1%
6	2	< 0.1%
5	4	< 0.1%
4	9	0.1%
3	13	0.1%
2	55	0.3%
1	180	1.1%

transf_entre_regionais
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	128.1 KiB

	16278
	97
	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Common Values

Value	Count	Frequency (%)
	16278	99.4%
	97	0.6%
	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
	16278	99.4%
	97	0.6%
	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

truecaller
Real number (ℝ_≥0)

ZEROS

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02699071812

Minimum	0
Maximum	9
Zeros	16174
Zeros (%)	98.8%
Negative	0
Negative (%)	0.0%
Memory size	128.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3064766634
Coefficient of variation (CV)	11.35489104
Kurtosis	308.1931786
Mean	0.02699071812
Median Absolute Deviation (MAD)	0
Skewness	15.92348546
Sum	442
Variance	0.0939279452
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	16174	98.8%
1	105	0.6%
2	37	0.2%
3	22	0.1%
4	17	0.1%
5	9	0.1%
6	5	< 0.1%
7	4	< 0.1%
9	2	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16174	98.8%
1	105	0.6%
2	37	0.2%
3	22	0.1%
4	17	0.1%
5	9	0.1%
6	5	< 0.1%
7	4	< 0.1%
8	1	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	1	< 0.1%
7	4	< 0.1%
6	5	< 0.1%
5	9	0.1%
4	17	0.1%
3	22	0.1%
2	37	0.2%
1	105	0.6%
0	16174	98.8%

venda
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	128.1 KiB

	11542
	4834

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Common Values

Value	Count	Frequency (%)
	11542	70.5%
	4834	29.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
	11542	70.5%
	4834	29.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values